SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 46193: A warning occurs when you use a range of macro variables in the SQL procedure and the case of those variable names is not the same

DetailsAboutRate It

In the SQL procedure (PROC), the SELECT statement's INTO clause is case-sensitive. Consequently, when you use a range of macro variables in the INTO clause and those variable names have inconsistent casing, a warning similar to the following occurs:

  select name into :mvar1 - :Mvar20
  WARNING: INTO Clause :mvar1 thru :Mvar20 does not specify a valid sequence of macro variables.


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASIRIX9.4 TS1M0
AIX9.4 TS1M0
HP-UX9.4 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.4 TS1M0
Microsoft Windows XP 64-bit Edition9.4 TS1M0
Microsoft® Windows® for x649.4 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.4 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.4 TS1M0
Microsoft Windows Server 2003 Standard Edition9.4 TS1M0
Microsoft Windows Server 2003 for x649.4 TS1M0
ABI+ for Intel Architecture9.4 TS1M0
64-bit Enabled Solaris9.4 TS1M0
HP-UX IPF9.4 TS1M0
64-bit Enabled HP-UX9.4 TS1M0
Windows Vista for x649.4 TS1M0
64-bit Enabled AIX9.4 TS1M0
Windows Vista9.4 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.4 TS1M0
Microsoft Windows Server 20089.4 TS1M0
Microsoft Windows Server 2008 for x649.4 TS1M0
Microsoft Windows XP Professional9.4 TS1M0
Tru64 UNIX9.4 TS1M0
Solaris for x649.4 TS1M0
Solaris9.4 TS1M0
OpenVMS on HP Integrity9.4 TS1M0
OpenVMS Alpha9.4 TS1M0
Linux on Itanium9.4 TS1M0
Linux for x649.4 TS1M0
Linux9.4 TS1M0
DB2 Universal Database on AIX9.4 TS1M0
DB2 Universal Database on Linux x649.4 TS1M0
Greenplum on Linux x649.4 TS1M0
Netezza TwinFin 32bit blade9.4 TS1M0
Netezza TwinFin 32-bit SMP Hosts9.4 TS1M0
Netezza TwinFin 64-bit S-Blades9.4 TS1M0
Netezza TwinFin 64-bit SMP Hosts9.4 TS1M0
Teradata on Linux9.4 TS1M0
z/OS9.4 TS1M0
Z649.4 TS1M0
OpenVMS VAX9.4 TS1M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9.4 TS1M0
Aster Data nCluster on Linux x649.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.